Skip Headers

Oracle® Database Companion CD Installation Guide 10g Release 2 (10.2) for Microsoft Windows (x64) Part Number B15686-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# 1 Oracle Database Companion CD Installation Overview

This chapter provides an overview of the products available on the Oracle Database Companion CD and describes issues to consider before you install the products:

- Overview of the Installation Process

- Products Available in the Oracle Database 10g Products Installation Type

## Overview of the Installation Process

The installation process consists of six steps:

1. Read the release notes: Read the Oracle Database 10g release 2 (10.2) release notes before you begin the installation. The release notes are available with the platform-specific documentation. The latest version of the release notes is available on Oracle Technology Network at:

   `http://www.oracle.com/technology/documentation`

2. Plan the installation: This chapter describes the products in the installation types and provides information that you must understand before installing the software.

   You also may want to refer to Appendix A, "Frequently Asked Questions about Installation," in Oracle Database Installation Guide. This appendix advises on the best way to install Oracle products depending on your site's requirements.

3. Verify system requirements: Chapter 2 describes the minimum requirements that your system must meet before you install the software.

4. Install the software: Use the following sections to install the Oracle Database Companion CD products:

   - Chapter 3 describes how to use Oracle Universal Installer to install the software.

   - Appendix A describes how to perform the installation using silent or noninteractive mode using response files. It also explains how to run Oracle Workflow Configuration Assistant in noninteractive mode.

   - "Installing and Using Oracle Components in Different Languages" describes how to install and use Oracle Database Companion CD components in different languages.

   - Appendix D provides installation troubleshooting advice.

5. Get started using the Companion CD products: Use the following sections to get started using Oracle Database Companion CD products:

   - "Configuring Locale and Character Sets with the NLS_LANG Parameter" explains how to configure the Oracle Database Companion CD locale and character sets.

   - Appendix C describes how to check and modify port numbers.

## Products Available in the Oracle Database 10g Products Installation Type

The following products are available with the Oracle Database 10g Products installation type:

- Oracle JDBC Development Drivers

- Oracle SQLJ

- Oracle Database Examples

- Oracle Text Supplied Knowledge Bases

- Oracle Ultra Search

- Natively Compiled Java Libraries

- JPublisher

Note: The Summary window of Oracle Universal Installer provides a detailed list of the products available with the Oracle Database 10g Products installation type. Legato Single Server Version (LSSV) is no longer supported on Oracle Database. Oracle Database Recovery Manager (RMAN), which is a backup and recovery tool integrated into Oracle Database. Oracle Database Backup and Recovery Basics covers RMAN in more detail.

### Oracle JDBC Development Drivers

Oracle provides a set of JDBC drivers that you can use for debugging your code and other deployment scenarios. These drivers can access Oracle Database release 8.1.7 or later.

See Also: Oracle Technology Network (`http://www.oracle.com/technology/index.html`) for more information on Oracle JDBC Drivers and Oracle Call Interface Oracle Call Interface Programmer's Guide

### Oracle SQLJ

Oracle SQLJ enables applications programmers to embed SQL operations in Java code in a way that is compatible with the Java design philosophy. A SQLJ program is a Java program containing embedded SQL statements. Oracle SQLJ offers extensions to support dynamic SQL operations—those that are not predefined, where the operations themselves can change in real-time. It is also possible to use dynamic SQL operations through JDBC code or PL/SQL code within a SQLJ application. Typical applications contain much more static SQL than dynamic SQL. SQLJ has both a translator and a runtime component and is smoothly integrated into your development environment.

### Oracle Database Examples

Oracle Database Examples include a variety of examples and product demonstrations that you can use to learn about the products, options, and features of Oracle Database. Many of these examples are designed to work with the Sample Schemas which you can optionally install in any Oracle database. Many of the documents in the Oracle Online Documentation Library use the example programs and scripts provided with the Oracle Database Examples.

#### Required Products

Before you can use the Oracle Database Examples, you must install the Sample Schemas into an Oracle database. When you install Oracle Database, or use Database Configuration Assistant (DBCA) to create a new database, you can choose to include the Sample Schemas when you create the database. You can also manually install the Sample Schemas into an existing database.

See Also: Oracle Database Sample Schemas for information about manually installing the Sample Schemas into an existing database

### Oracle Text Supplied Knowledge Bases

The Oracle Database 10g Products installation type installs two Oracle Text knowledge bases, English and French. You can extend the supplied knowledge bases depending on your requirements. Alternatively, you can create your own knowledge bases, in languages other than English and French.

See Also: Oracle Text Reference for more information about creating and extending knowledge bases

### Oracle Ultra Search

You can use Oracle Ultra Search to build different kinds of search applications. It lets you index and search Web sites, database tables, files, mailing lists, Oracle Application Server Portals, and user-defined data sources.

### Natively Compiled Java Libraries

The Oracle Database 10g Products installation type installs JAccelerator and Oracle interMedia Image Accelerator which contains the natively compiled Java libraries (NCOMPs) for Oracle JVM and Oracle interMedia. These libraries are required to improve the performance of these products on your platform.

### JPublisher

JPublisher is a Java utility that generates Java classes to represent the following user-defined database entities in a Java program:

- SQL object types

- Object reference types (REF types)

- SQL collection types (VARRAY types or nested table types)

- PL/SQL packages

- Server-side Java classes

- SQL queries and DML statements

You can use JPublisher to specify and customize the mapping of SQL object types, object reference types, and collection types (VARRAYs or nested tables) to Java classes in a strongly typed paradigm.

JPublisher also can generate classes for PL/SQL packages. These classes have wrapper methods to invoke the stored procedures in the PL/SQL packages.

In addition, JPublisher simplifies access to PL/SQL-only types from Java. You can employ predefined or user-defined mappings between PL/SQL and SQL types, as well as use PL/SQL conversion functions between such types. With such type correspondences in place, JPublisher can automatically generate the required Java and PL/SQL code.

In a similar way that SQL or PL/SQL entities publish to Java, you can publish server-side Java classes to client-side Java classes. Doing this enables applications to make direct calls to Java classes in the database.JPublisher lets you expose generated Java classes as Web services, for example. You can publish either SQL or PL/SQL entities or server-side Java entities.

JPublisher uses SQLJ code in most Java classes that it generates, so it includes Oracle SQLJ Translator and Oracle SQLJ Runtime. Oracle SQLJ is a standard way to embed SQL statements in Java programs.

Oracle SQLJ Translator

Because JPublisher uses SQLJ code in its generated classes, it automatically invokes the Oracle SQLJ translator during the code generation process, as necessary. The translator converts embedded SQL statements into JDBC calls.

Oracle SQLJ Runtime

Oracle SQLJ Runtime is used during program execution to execute most classes that were generated by JPublisher. SQLJ Runtime is a thin layer of pure Java code that runs above the JDBC driver. It acts as an intermediary that reads information about SQL operations and passing instructions along to the JDBC driver.

See Also: Oracle Database JPublisher User's Guide